Challenge 1: Chipotle Sales
Dataset - See challenge questions below.
Link to GitHub repository, including data and final output.
Click the bottom right corner of the window above to view in full-screen mode.
1. About the dataset
The dataset contains a table of sales transaction at a Chipotle restaurant. A copy of the data dictionary is below.
| Column | Description |
|---|---|
| order_id | The ID of each order (not unqiue) |
| quantity | Number of item_name ordered |
| item_name | Name of the item ordered |
| choice_description | Ingredients in the item_name |
| item_price | Selling price of the item_name |
There are nine questions in total, querying different aspects of the dataset.
- Which was the most-ordered item?
- For the most-ordered item, how many items were ordered?
- What was the most ordered item in the choice_description column?
- How many items were ordered in total?
- Turn the item price into a float.
- How much was the revenue for the period in the dataset?
- How many orders were made in the period?
- What is the average revenue amount per order?
- How many different items are sold?
- Imported the dataset using the link provided through Power Query, checked for null and error values.
- Removed "[" and "]" in the item_description column.
- Replaced "-" with " " in the item_name column.
Each answer had its own Query as presented in the Summary Tab.